Magnum One

home *** CD-ROM | disk | FTP | other *** search

/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d3 / dbasetut.arc / D105 < prev next >

Wrap

Text File | 1990-06-16 | 3.0 KB | 227 lines

*105010 C13,0 rââΦ─ räâ° Session 1 ∙ What is a database? rºâΦ ¿─ rüäÉ ╨ rüàÉ ╨ rüåÉ ö In addition to data on books, the û rüç≡ ┌ è─┐ rÉçÉ à library also keeps data on each borrower: ô rüê≡ │ ràêÉ è rÅê≡│ ┴ rüë≡ │ ràëÉ BOOK rÅë≡│ ┴ rüè≡ │ ràèÉ è rÅè≡│ rÉèÉ ê Name, Address, Telephone number, Ö rüï≡ │ ràïÉ data rÅï≡│ ┴ rüî≡ │ ràîÉ è rÅî≡│ rÉîÉ ê and Social Security number. ₧ rüì≡ └ è─┘ ┴ rüÄÉ ╨ rüÅÉ ö The BOOK data and the BORROWER data are ò rüÉÉ ö kept in separate files. Ñ rüæÉ ╨ rüÆÉ ╨ rüôÉ ╨ rüöÉ ╨ rüòÉ ╨ rüûÉ ╨ rüùÉ ╨ rüÿÉ ╧ q╧ÿÉP,6,,,,, a1,P,,,,,, *105020 C14,0 r┬º≡ è─┐ d╠¿≡ à│┘ l╦¡≡ è─└ u┴¼≡ à│┌ r├⌐ÉBORROWER r├ïÉ r┼½Édata q╧ÿÉP,1,,,,, a1,P,,,,,, *105030 C14,0 rªÿ≡Press r¡ÿ°──┘ r▒ÿ≡ to continue or r├ÿ°F5 r┼ÿ≡ to exit q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *105040 C15,0 ròå° ¿ ròç° ⌐ ròê° ë rÿè° á rÿî° ¢ ròÅ° º ròÉ° ù q╧ÿ°P,1,,,,, a1,P,,,,,, *105050 C2,0 ròåÉA third type of data maintained by the ròçÉlibrary is LOAN data. ròèÉThe call number of the book on loan ròïÉis matched with the borrower's ròîÉSocial Security number. ç ríÅ≡┌ è─┐ ríÉ≡│ róÉÉ è r¼É≡│ ríæ≡│ róæÉ LOAN r¼æ≡│ ríÆ≡│ róÆÉ è r¼Æ≡│ ríô≡│ róôÉ data r¼ô≡│ rÆöÉCall number r₧öα ä─ è ä─ r▒öÉSS number ríò≡└ è─┘ q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *105060 C14,0 ròå≡ º ròç≡ ÿ ròè≡ ñ ròï≡ ₧ ròî≡ ù rªÿ≡ ¿ q╧ÿ╕P,1,,,,, a1,P,,,,,, *105070 C2,0 ròåÉWith dBASE IV, the library can link ròçÉ Ñ ròêÉdata in the BOOK file with data in ròèÉthe BORROWER file by using the data ròïÉ ₧ ròîÉin the LOAN file. q╧ÿ╕P,8,,,,, a1,P,,,,,, *105080 C12,0 rë¡α│ d╟¡α││ dë«α││ d╟»α││ rë░α│ r╟▒α│ dë▒α││ d╟▓α││ dë│α│└ l╟┤α┘─ rè┤α── l┼┤α── rî┤α── l├┤α─── rÄ┤α── l└┤α─── rÉ┤α─ l╜┤α─── q╧ÿ╕P,3,,,,, a1,P,,,,,, *105090 C14,0 rªÿ≡Press r¡ÿ°──┘ r▒ÿ≡ to continue or r├ÿ°F5 r┼ÿ≡ to exit q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *105100 C7,0 ròå╕ ú ròê╕ ó ròè╕ ú ròî╕ ö q╧ÿ╕P,1,,,,, a1,P,,,,,, *105110 C2,0 ròåÉThe library can mail overdue notices ròêÉon books identified by their call numbers ròèÉto borrowers identified by their Social ròîÉSecurity numbers. Ö q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *105120 C7,0 rüå╕ ╧ rüç╕ ╧ rüê╕ ╧ rüë╕ ╧ rüè╕ ╧ rüï╕ ╧ rüî╕ ╧ rüì╕ ╧ rüÄ╕ ╧ rüÅ╕ ╧ rüÉ╕ ╧ rüæ╕ ╧ rüÆ╕ ╧ rüô╕ ╧ rüö╕ ╧ rüò╕ ╧ rüû╕ ╧ rüù╕ ╧ rüÿ╕ ╧ q╧ÿ╕P,2,,,,, a1,P,,,,,, *105130 C2,0 rëèÉYou have completed Session 1 - r¿è≡What is a database? rëìÉPress rÉì°S ræìÉ for the r¢ì≡summary róìÉ. rëÅÉPress rÉÅ°──┘ röÅÉ to continue with Session 2 - r│Å≡dBASE IV basics r┬ÅÉ. rëæÉPress rÉæ°F5 rÆæÉ to return to the rÑæ≡Main Menu r«æÉ. q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,C,D201,,,&H0D,, a8,C,D1SU,,,&H73,, a8,C,D1SU,,,&H53,, a8,C,D002,,,&H003F,,